<?php
namespace app\admin\controller;

class Goodsrec extends Base
{
    //列表
    public function lists(){
        if(is_post()){
            $d = $this->post;
            $map = [];
            if($d['keyword']!=''){ $map[] = ['and','title','like',"%{$d['keyword']}%"]; }

            $w  = where($map);
            $rs = $this->db->query("select * from goods_rec $w[0] order by sort desc, id desc".limit($d['page'],$d['limit']), $w[1],'',true);
            if($rs){
                foreach ($rs[0] as $key=>$val) {
                    $rs[0][$key]['create_time'] = date('Y-m-d H:i',$val['create_time']);
                }
                suc($rs[0],$rs[1]);
            }else{
                suc([],0);
            }
            $this->fetch();
        }
        return $this->fetch();
    }

    //添加
    public function add(){
        if(is_post()){
            $d = $this->post;
            $d['create_time'] = time();
            $id = $this->db->insert('goods_rec',$d);
            if ($id) {
                cookie('js_msg','添加成功');
                cookie('js_function','preload');
                return suc();
            }else{
                err('添加失败');
            }
        }
        return $this->fetch();
    }

    //编辑
    public function edit(){
        if(is_post()){
            $d = $this->post;
            $d['update_time'] = time();
            $id = $this->db->update('goods_rec',$d);
            if ($id) {
                cookie('js_msg','修改成功');
                cookie('js_function','preload');
                return suc();
            }else{
                err('修改失败');
            }
        }
        $id = $this->get['id'];
        $info = $this->db->query("select * from goods_rec where id=?",[$id],1);
        return $this->fetch(['info'=>$info]);
    }
    //删除
    public function del(){
        if(is_post()){
            $d = $this->post;
            $res = $this->db->query("select id from goods where rec_id = ? limit 1",[$d['id']],1);
            if ($res) {
                err('该推荐位置已使用,不能被删除!');
            }else{
                $this->db->delete('goods_rec',$d['id']);
            }
            cookie('js_msg','删除成功');
            cookie('js_function','close|reload');
            return suc();
        }
    }

    #批量删除
    function delall(){
      if(is_post()){
            $d = $this->post;
            $ids = $d['id'];
            foreach($ids as $id){
                $res = $this->db->query("select id from goods where rec_id = ? limit 1",[$id],1);
                if ($res) {
                    err('该推荐位置已使用,不能被删除!');
                }else{
                    $this->db->delete('goods_rec',$id);
                }
            }
            cookie('js_msg','删除成功');
            cookie('js_function','close|reload');
            return suc();
      }
    }

    //详情
    public function detail($id){
        return $this->fetch();
    }
}
